import pandas as pd

# 读取Excel文件
file_path = 'data/2023-09-13.xlsx'
df = pd.read_excel(file_path)

# 检查数据框的前几行以确保正确读取
print(df.head())

# 计算‘温度’列的平均值
if '温度' in df.columns:
    average_temperature = df['温度'].mean()
    print(f"温度的平均值是: {average_temperature}")
else:
    print("文件中不存在‘温度’列")